[dbo].[BAEImisNameAddressGetPreferredMail]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisNameAddressGetPreferredMail

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@Id	varchar(10)	10

SQL Script

create procedure [dbo].[BAEImisNameAddressGetPreferredMail] @Id varchar(10) as
SELECT DISTINCT ADDRESS_NUM
FROM Name_Address
WHERE ID = @Id AND PREFERRED_MAIL = 1

GO

Uses

[dbo].[Name_Address]
dbo